---
title: WorksheetFunction.PDuration Method (Excel)
keywords: vbaxl10.chm137443
f1_keywords:
- vbaxl10.chm137443
ms.prod: excel
ms.assetid: 6f2e9e02-c629-82e7-bdba-5206a5d1cea5
ms.date: 06/08/2017
---


# WorksheetFunction.PDuration Method (Excel)

Returns the number of periods required by an investment to reach a specified value.


## Syntax

 _expression_ . **PDuration**_(Arg1,_ _Arg2,_ _Arg3)_

 _expression_ A variable that represents a[WorksheetFunction Object (Excel)](worksheetfunction-object-excel.md) object.


### Parameters



|**Name**|**Required/Optional**|**Data type**|**Description**|
|:-----|:-----|:-----|:-----|
| _Arg1_|Required|DOUBLE|Interest rate per period.|
| _Arg2_|Required|DOUBLE|Present value of the investment.|
| _Arg3_|Required|DOUBLE|Desired future value of the investment.|

### Return value

 **DOUBLE**


## See also


#### Concepts


[WorksheetFunction Object](worksheetfunction-object-excel.md)

